Pandas Profiling Report

Dataset statistics

Number of variables	21
Number of observations	21597
Missing cells	6281
Missing cells (%)	1.4%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	3.5 MiB
Average record size in memory	168.0 B

Variable types

Numeric	15
DateTime	1
Boolean	1
Categorical	3
Text	1

Alerts

`price` is highly overall correlated with `sqft_living` and 2 other fields	High correlation
`bedrooms` is highly overall correlated with `bathrooms` and 2 other fields	High correlation
`bathrooms` is highly overall correlated with `bedrooms` and 5 other fields	High correlation
`sqft_living` is highly overall correlated with `price` and 4 other fields	High correlation
`sqft_lot` is highly overall correlated with `sqft_lot15`	High correlation
`floors` is highly overall correlated with `bathrooms` and 2 other fields	High correlation
`sqft_above` is highly overall correlated with `price` and 5 other fields	High correlation
`yr_built` is highly overall correlated with `bathrooms` and 1 other fields	High correlation
`zipcode` is highly overall correlated with `long`	High correlation
`long` is highly overall correlated with `zipcode`	High correlation
`sqft_living15` is highly overall correlated with `price` and 3 other fields	High correlation
`sqft_lot15` is highly overall correlated with `sqft_lot`	High correlation
`waterfront` is highly overall correlated with `view`	High correlation
`view` is highly overall correlated with `waterfront`	High correlation
`waterfront` is highly imbalanced (93.6%)	Imbalance
`view` is highly imbalanced (72.3%)	Imbalance
`waterfront` has 2376 (11.0%) missing values	Missing
`yr_renovated` has 3842 (17.8%) missing values	Missing
`yr_renovated` has 17011 (78.8%) zeros	Zeros

Reproduction

Analysis started	2023-10-23 08:47:40.820110
Analysis finished	2023-10-23 08:48:04.131658
Duration	23.31 seconds
Software version	ydata-profiling vv4.6.0
Download configuration	config.json

id
Real number (ℝ)

Distinct	21420
Distinct (%)	99.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.5804743 × 10⁹

Minimum	1000102
Maximum	9.9000002 × 10⁹
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	168.9 KiB

Quantile statistics

Minimum	1000102
5-th percentile	5.1274039 × 10⁸
Q1	2.1230492 × 10⁹
median	3.9049304 × 10⁹
Q3	7.3089005 × 10⁹
95-th percentile	9.2973004 × 10⁹
Maximum	9.9000002 × 10⁹
Range	9.8990001 × 10⁹
Interquartile range (IQR)	5.1858513 × 10⁹

Descriptive statistics

Standard deviation	2.8767357 × 10⁹
Coefficient of variation (CV)	0.6280432
Kurtosis	-1.2607499
Mean	4.5804743 × 10⁹
Median Absolute Deviation (MAD)	2.4025303 × 10⁹
Skewness	0.24322552
Sum	9.8924503 × 10¹³
Variance	8.2756084 × 10¹⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
795000620	3	< 0.1%
8910500150	2	< 0.1%
7409700215	2	< 0.1%
1995200200	2	< 0.1%
9211500620	2	< 0.1%
1524079093	2	< 0.1%
4305200070	2	< 0.1%
1450100390	2	< 0.1%
7893805650	2	< 0.1%
109200390	2	< 0.1%
Other values (21410)	21576	99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1000102	2	< 0.1%
1200019	1	< 0.1%
1200021	1	< 0.1%
2800031	1	< 0.1%
3600057	1	< 0.1%
3600072	1	< 0.1%
3800008	1	< 0.1%
5200087	1	< 0.1%
6200017	1	< 0.1%
7200080	1	< 0.1%

Value	Count	Frequency (%)
9900000190	1	< 0.1%
9895000040	1	< 0.1%
9842300540	1	< 0.1%
9842300485	1	< 0.1%
9842300095	1	< 0.1%
9842300036	1	< 0.1%
9839301165	1	< 0.1%
9839301060	1	< 0.1%
9839301055	1	< 0.1%
9839300875	1	< 0.1%

date
Date

Distinct	372
Distinct (%)	1.7%
Missing	0
Missing (%)	0.0%
Memory size	168.9 KiB

Minimum	2014-05-02 00:00:00
Maximum	2015-05-27 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

price
Real number (ℝ)

HIGH CORRELATION

Distinct	3622
Distinct (%)	16.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	540296.57

Minimum	78000
Maximum	7700000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	168.9 KiB

Quantile statistics

Minimum	78000
5-th percentile	210000
Q1	322000
median	450000
Q3	645000
95-th percentile	1160000
Maximum	7700000
Range	7622000
Interquartile range (IQR)	323000

Descriptive statistics

Standard deviation	367368.14
Coefficient of variation (CV)	0.67993794
Kurtosis	34.541359
Mean	540296.57
Median Absolute Deviation (MAD)	150000
Skewness	4.0233647
Sum	1.1668785 × 10¹⁰
Variance	1.3495935 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
450000	172	0.8%
350000	172	0.8%
550000	159	0.7%
500000	152	0.7%
425000	150	0.7%
325000	148	0.7%
400000	145	0.7%
375000	138	0.6%
300000	133	0.6%
525000	131	0.6%
Other values (3612)	20097	93.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
78000	1	< 0.1%
80000	1	< 0.1%
81000	1	< 0.1%
82000	1	< 0.1%
82500	1	< 0.1%
83000	1	< 0.1%
84000	1	< 0.1%
85000	2	< 0.1%
86500	1	< 0.1%
89000	1	< 0.1%

Value	Count	Frequency (%)
7700000	1	< 0.1%
7060000	1	< 0.1%
6890000	1	< 0.1%
5570000	1	< 0.1%
5350000	1	< 0.1%
5300000	1	< 0.1%
5110000	1	< 0.1%
4670000	1	< 0.1%
4500000	1	< 0.1%
4490000	1	< 0.1%

bedrooms
Real number (ℝ)

HIGH CORRELATION

Distinct	12
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.3732

Minimum	1
Maximum	33
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	168.9 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	3
median	3
Q3	4
95-th percentile	5
Maximum	33
Range	32
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.92629889
Coefficient of variation (CV)	0.27460539
Kurtosis	49.821835
Mean	3.3732
Median Absolute Deviation (MAD)	1
Skewness	2.0236412
Sum	72851
Variance	0.85802964
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
3	9824	45.5%
4	6882	31.9%
2	2760	12.8%
5	1601	7.4%
6	272	1.3%
1	196	0.9%
7	38	0.2%
8	13	0.1%
9	6	< 0.1%
10	3	< 0.1%
Other values (2)	2	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	196	0.9%
2	2760	12.8%
3	9824	45.5%
4	6882	31.9%
5	1601	7.4%
6	272	1.3%
7	38	0.2%
8	13	0.1%
9	6	< 0.1%
10	3	< 0.1%

Value	Count	Frequency (%)
33	1	< 0.1%
11	1	< 0.1%
10	3	< 0.1%
9	6	< 0.1%
8	13	0.1%
7	38	0.2%
6	272	1.3%
5	1601	7.4%
4	6882	31.9%
3	9824	45.5%

bathrooms
Real number (ℝ)

HIGH CORRELATION

Distinct	29
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.1158263

Minimum	0.5
Maximum	8
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	168.9 KiB

Quantile statistics

Minimum	0.5
5-th percentile	1
Q1	1.75
median	2.25
Q3	2.5
95-th percentile	3.5
Maximum	8
Range	7.5
Interquartile range (IQR)	0.75

Descriptive statistics

Standard deviation	0.7689843
Coefficient of variation (CV)	0.36344397
Kurtosis	1.2793153
Mean	2.1158263
Median Absolute Deviation (MAD)	0.5
Skewness	0.51970928
Sum	45695.5
Variance	0.59133685
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=29)

Value	Count	Frequency (%)
2.5	5377	24.9%
1	3851	17.8%
1.75	3048	14.1%
2.25	2047	9.5%
2	1930	8.9%
1.5	1445	6.7%
2.75	1185	5.5%
3	753	3.5%
3.5	731	3.4%
3.25	589	2.7%
Other values (19)	641	3.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.5	4	< 0.1%
0.75	71	0.3%
1	3851	17.8%
1.25	9	< 0.1%
1.5	1445	6.7%
1.75	3048	14.1%
2	1930	8.9%
2.25	2047	9.5%
2.5	5377	24.9%
2.75	1185	5.5%

Value	Count	Frequency (%)
8	2	< 0.1%
7.75	1	< 0.1%
7.5	1	< 0.1%
6.75	2	< 0.1%
6.5	2	< 0.1%
6.25	2	< 0.1%
6	6	< 0.1%
5.75	4	< 0.1%
5.5	10	< 0.1%
5.25	13	0.1%

sqft_living
Real number (ℝ)

HIGH CORRELATION

Distinct	1034
Distinct (%)	4.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2080.3219

Minimum	370
Maximum	13540
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	168.9 KiB

Quantile statistics

Minimum	370
5-th percentile	940
Q1	1430
median	1910
Q3	2550
95-th percentile	3760
Maximum	13540
Range	13170
Interquartile range (IQR)	1120

Descriptive statistics

Standard deviation	918.10613
Coefficient of variation (CV)	0.44132889
Kurtosis	5.252102
Mean	2080.3219
Median Absolute Deviation (MAD)	540
Skewness	1.4732155
Sum	44928711
Variance	842918.86
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1300	138	0.6%
1400	135	0.6%
1440	133	0.6%
1800	129	0.6%
1660	129	0.6%
1010	129	0.6%
1820	128	0.6%
1480	125	0.6%
1720	125	0.6%
1540	124	0.6%
Other values (1024)	20302	94.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
370	1	< 0.1%
380	1	< 0.1%
390	1	< 0.1%
410	1	< 0.1%
420	2	< 0.1%
430	1	< 0.1%
440	1	< 0.1%
460	1	< 0.1%
470	2	< 0.1%
480	2	< 0.1%

Value	Count	Frequency (%)
13540	1	< 0.1%
12050	1	< 0.1%
10040	1	< 0.1%
9890	1	< 0.1%
9640	1	< 0.1%
9200	1	< 0.1%
8670	1	< 0.1%
8020	1	< 0.1%
8010	1	< 0.1%
8000	1	< 0.1%

sqft_lot
Real number (ℝ)

HIGH CORRELATION

Distinct	9776
Distinct (%)	45.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15099.409

Minimum	520
Maximum	1651359
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	168.9 KiB

Quantile statistics

Minimum	520
5-th percentile	1800.8
Q1	5040
median	7618
Q3	10685
95-th percentile	43307.2
Maximum	1651359
Range	1650839
Interquartile range (IQR)	5645

Descriptive statistics

Standard deviation	41412.637
Coefficient of variation (CV)	2.7426661
Kurtosis	285.49581
Mean	15099.409
Median Absolute Deviation (MAD)	2618
Skewness	13.072604
Sum	3.2610193 × 10⁸
Variance	1.7150065 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5000	358	1.7%
6000	290	1.3%
4000	251	1.2%
7200	220	1.0%
4800	119	0.6%
7500	119	0.6%
4500	114	0.5%
8400	111	0.5%
9600	109	0.5%
3600	103	0.5%
Other values (9766)	19803	91.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
520	1	< 0.1%
572	1	< 0.1%
600	1	< 0.1%
609	1	< 0.1%
635	1	< 0.1%
638	1	< 0.1%
649	2	< 0.1%
651	1	< 0.1%
675	1	< 0.1%
676	1	< 0.1%

Value	Count	Frequency (%)
1651359	1	< 0.1%
1164794	1	< 0.1%
1074218	1	< 0.1%
1024068	1	< 0.1%
982998	1	< 0.1%
982278	1	< 0.1%
920423	1	< 0.1%
881654	1	< 0.1%
871200	2	< 0.1%
843309	1	< 0.1%

floors
Real number (ℝ)

HIGH CORRELATION

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.4940964

Minimum	1
Maximum	3.5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	168.9 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1.5
Q3	2
95-th percentile	2
Maximum	3.5
Range	2.5
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.53968279
Coefficient of variation (CV)	0.36121015
Kurtosis	-0.49106576
Mean	1.4940964
Median Absolute Deviation (MAD)	0.5
Skewness	0.61449698
Sum	32268
Variance	0.29125751
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
1	10673	49.4%
2	8235	38.1%
1.5	1910	8.8%
3	611	2.8%
2.5	161	0.7%
3.5	7	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	10673	49.4%
1.5	1910	8.8%
2	8235	38.1%
2.5	161	0.7%
3	611	2.8%
3.5	7	< 0.1%

Value	Count	Frequency (%)
3.5	7	< 0.1%
3	611	2.8%
2.5	161	0.7%
2	8235	38.1%
1.5	1910	8.8%
1	10673	49.4%

waterfront
Boolean

HIGH CORRELATION IMBALANCE MISSING

Distinct	2
Distinct (%)	< 0.1%
Missing	2376
Missing (%)	11.0%
Memory size	42.3 KiB

False	19075
True	146
(Missing)	2376

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	19075	88.3%
True	146	0.7%
(Missing)	2376	11.0%

view
Categorical

HIGH CORRELATION IMBALANCE

Distinct	5
Distinct (%)	< 0.1%
Missing	63
Missing (%)	0.3%
Memory size	168.9 KiB

NONE	19422
AVERAGE	957
GOOD	508
FAIR	330
EXCELLENT	317

Length

Max length	9
Median length	4
Mean length	4.2069286
Min length	4

Characters and Unicode

Total characters	90592
Distinct characters	14
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	NONE
2nd row	NONE
3rd row	NONE
4th row	NONE
5th row	NONE

Common Values

Value	Count	Frequency (%)
NONE	19422	89.9%
AVERAGE	957	4.4%
GOOD	508	2.4%
FAIR	330	1.5%
EXCELLENT	317	1.5%
(Missing)	63	0.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
none	19422	90.2%
average	957	4.4%
good	508	2.4%
fair	330	1.5%
excellent	317	1.5%

Most occurring characters

Value	Count	Frequency (%)
N	39161	43.2%
E	22287	24.6%
O	20438	22.6%
A	2244	2.5%
G	1465	1.6%
R	1287	1.4%
V	957	1.1%
L	634	0.7%
D	508	0.6%
F	330	0.4%
Other values (4)	1281	1.4%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	90592	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
N	39161	43.2%
E	22287	24.6%
O	20438	22.6%
A	2244	2.5%
G	1465	1.6%
R	1287	1.4%
V	957	1.1%
L	634	0.7%
D	508	0.6%
F	330	0.4%
Other values (4)	1281	1.4%

Most occurring scripts

Value	Count	Frequency (%)
Latin	90592	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
N	39161	43.2%
E	22287	24.6%
O	20438	22.6%
A	2244	2.5%
G	1465	1.6%
R	1287	1.4%
V	957	1.1%
L	634	0.7%
D	508	0.6%
F	330	0.4%
Other values (4)	1281	1.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	90592	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
N	39161	43.2%
E	22287	24.6%
O	20438	22.6%
A	2244	2.5%
G	1465	1.6%
R	1287	1.4%
V	957	1.1%
L	634	0.7%
D	508	0.6%
F	330	0.4%
Other values (4)	1281	1.4%

condition
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	168.9 KiB

Average	14020
Good	5677
Very Good	1701
Fair	170
Poor	29

Length

Max length	9
Median length	7
Mean length	6.3412974
Min length	4

Characters and Unicode

Total characters	136953
Distinct characters	15
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Average
2nd row	Average
3rd row	Average
4th row	Very Good
5th row	Average

Common Values

Value	Count	Frequency (%)
Average	14020	64.9%
Good	5677	26.3%
Very Good	1701	7.9%
Fair	170	0.8%
Poor	29	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
average	14020	60.2%
good	7378	31.7%
very	1701	7.3%
fair	170	0.7%
poor	29	0.1%

Most occurring characters

Value	Count	Frequency (%)
e	29741	21.7%
r	15920	11.6%
o	14814	10.8%
a	14190	10.4%
A	14020	10.2%
v	14020	10.2%
g	14020	10.2%
G	7378	5.4%
d	7378	5.4%
V	1701	1.2%
Other values (5)	3771	2.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	111954	81.7%
Uppercase Letter	23298	17.0%
Space Separator	1701	1.2%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	29741	26.6%
r	15920	14.2%
o	14814	13.2%
a	14190	12.7%
v	14020	12.5%
g	14020	12.5%
d	7378	6.6%
y	1701	1.5%
i	170	0.2%

Uppercase Letter

Value	Count	Frequency (%)
A	14020	60.2%
G	7378	31.7%
V	1701	7.3%
F	170	0.7%
P	29	0.1%

Space Separator

Value	Count	Frequency (%)
	1701	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	135252	98.8%
Common	1701	1.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	29741	22.0%
r	15920	11.8%
o	14814	11.0%
a	14190	10.5%
A	14020	10.4%
v	14020	10.4%
g	14020	10.4%
G	7378	5.5%
d	7378	5.5%
V	1701	1.3%
Other values (4)	2070	1.5%

Common

Value	Count	Frequency (%)
	1701	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	136953	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	29741	21.7%
r	15920	11.6%
o	14814	10.8%
a	14190	10.4%
A	14020	10.2%
v	14020	10.2%
g	14020	10.2%
G	7378	5.4%
d	7378	5.4%
V	1701	1.2%
Other values (5)	3771	2.8%

grade
Categorical

Distinct	11
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	168.9 KiB

7 Average	8974
8 Good	6065
9 Better	2615
6 Low Average	2038
10 Very Good	1134
Other values (6)	771

Length

Max length	13
Median length	12
Mean length	8.5886929
Min length	5

Characters and Unicode

Total characters	185490
Distinct characters	37
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	7 Average
2nd row	7 Average
3rd row	6 Low Average
4th row	7 Average
5th row	8 Good

Common Values

Value	Count	Frequency (%)
7 Average	8974	41.6%
8 Good	6065	28.1%
9 Better	2615	12.1%
6 Low Average	2038	9.4%
10 Very Good	1134	5.3%
11 Excellent	399	1.8%
5 Fair	242	1.1%
12 Luxury	89	0.4%
4 Low	27	0.1%
13 Mansion	13	0.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
average	11012	23.8%
7	8974	19.4%
good	7199	15.5%
8	6065	13.1%
9	2615	5.6%
better	2615	5.6%
low	2065	4.5%
6	2038	4.4%
10	1134	2.4%
very	1134	2.4%
Other values (11)	1515	3.3%

Most occurring characters

Value	Count	Frequency (%)
e	29186	15.7%
	24769	13.4%
o	16478	8.9%
r	15093	8.1%
a	11267	6.1%
A	11012	5.9%
v	11012	5.9%
g	11012	5.9%
7	8974	4.8%
d	7199	3.9%
Other values (27)	39488	21.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	112720	60.8%
Space Separator	24769	13.4%
Uppercase Letter	24769	13.4%
Decimal Number	23232	12.5%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	29186	25.9%
o	16478	14.6%
r	15093	13.4%
a	11267	10.0%
v	11012	9.8%
g	11012	9.8%
d	7199	6.4%
t	5629	5.0%
w	2065	1.8%
y	1223	1.1%
Other values (7)	2556	2.3%

Decimal Number

Value	Count	Frequency (%)
7	8974	38.6%
8	6065	26.1%
9	2615	11.3%
6	2038	8.8%
1	2034	8.8%
0	1134	4.9%
5	242	1.0%
2	89	0.4%
4	27	0.1%
3	14	0.1%

Uppercase Letter

Value	Count	Frequency (%)
A	11012	44.5%
G	7199	29.1%
B	2615	10.6%
L	2154	8.7%
V	1134	4.6%
E	399	1.6%
F	242	1.0%
M	13	0.1%
P	1	< 0.1%

Space Separator

Value	Count	Frequency (%)
	24769	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	137489	74.1%
Common	48001	25.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	29186	21.2%
o	16478	12.0%
r	15093	11.0%
a	11267	8.2%
A	11012	8.0%
v	11012	8.0%
g	11012	8.0%
d	7199	5.2%
G	7199	5.2%
t	5629	4.1%
Other values (16)	12402	9.0%

Common

Value	Count	Frequency (%)
	24769	51.6%
7	8974	18.7%
8	6065	12.6%
9	2615	5.4%
6	2038	4.2%
1	2034	4.2%
0	1134	2.4%
5	242	0.5%
2	89	0.2%
4	27	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	185490	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	29186	15.7%
	24769	13.4%
o	16478	8.9%
r	15093	8.1%
a	11267	6.1%
A	11012	5.9%
v	11012	5.9%
g	11012	5.9%
7	8974	4.8%
d	7199	3.9%
Other values (27)	39488	21.3%

sqft_above
Real number (ℝ)

HIGH CORRELATION

Distinct	942
Distinct (%)	4.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1788.5968

Minimum	370
Maximum	9410
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	168.9 KiB

Quantile statistics

Minimum	370
5-th percentile	850
Q1	1190
median	1560
Q3	2210
95-th percentile	3400
Maximum	9410
Range	9040
Interquartile range (IQR)	1020

Descriptive statistics

Standard deviation	827.75976
Coefficient of variation (CV)	0.4627984
Kurtosis	3.4055198
Mean	1788.5968
Median Absolute Deviation (MAD)	450
Skewness	1.4474342
Sum	38628326
Variance	685186.22
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1300	212	1.0%
1010	210	1.0%
1200	206	1.0%
1220	192	0.9%
1140	184	0.9%
1400	180	0.8%
1060	178	0.8%
1180	177	0.8%
1340	176	0.8%
1250	174	0.8%
Other values (932)	19708	91.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
370	1	< 0.1%
380	1	< 0.1%
390	1	< 0.1%
410	1	< 0.1%
420	2	< 0.1%
430	1	< 0.1%
440	1	< 0.1%
460	1	< 0.1%
470	2	< 0.1%
480	4	< 0.1%

Value	Count	Frequency (%)
9410	1	< 0.1%
8860	1	< 0.1%
8570	1	< 0.1%
8020	1	< 0.1%
7880	1	< 0.1%
7850	1	< 0.1%
7680	1	< 0.1%
7420	1	< 0.1%
7320	1	< 0.1%
6720	1	< 0.1%

sqft_basement
Text

Distinct	304
Distinct (%)	1.4%
Missing	0
Missing (%)	0.0%
Memory size	168.9 KiB

Length

Max length	6
Median length	3
Mean length	3.8160393
Min length	1

Characters and Unicode

Total characters	82415
Distinct characters	12
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	89 ?
Unique (%)	0.4%

Sample

1st row	0.0
2nd row	400.0
3rd row	0.0
4th row	910.0
5th row	0.0

Value	Count	Frequency (%)
0.0	12826	59.4%
	454	2.1%
600.0	217	1.0%
500.0	209	1.0%
700.0	208	1.0%
800.0	201	0.9%
400.0	184	0.9%
1000.0	148	0.7%
900.0	142	0.7%
300.0	142	0.7%
Other values (294)	6866	31.8%

Most occurring characters

Value	Count	Frequency (%)
0	44732	54.3%
.	21143	25.7%
1	3208	3.9%
5	1818	2.2%
2	1751	2.1%
4	1708	2.1%
8	1639	2.0%
6	1602	1.9%
7	1554	1.9%
3	1522	1.8%
Other values (2)	1738	2.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	60818	73.8%
Other Punctuation	21597	26.2%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	44732	73.6%
1	3208	5.3%
5	1818	3.0%
2	1751	2.9%
4	1708	2.8%
8	1639	2.7%
6	1602	2.6%
7	1554	2.6%
3	1522	2.5%
9	1284	2.1%

Other Punctuation

Value	Count	Frequency (%)
.	21143	97.9%
?	454	2.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	82415	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	44732	54.3%
.	21143	25.7%
1	3208	3.9%
5	1818	2.2%
2	1751	2.1%
4	1708	2.1%
8	1639	2.0%
6	1602	1.9%
7	1554	1.9%
3	1522	1.8%
Other values (2)	1738	2.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	82415	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	44732	54.3%
.	21143	25.7%
1	3208	3.9%
5	1818	2.2%
2	1751	2.1%
4	1708	2.1%
8	1639	2.0%
6	1602	1.9%
7	1554	1.9%
3	1522	1.8%
Other values (2)	1738	2.1%

yr_built
Real number (ℝ)

HIGH CORRELATION

Distinct	116
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1970.9997

Minimum	1900
Maximum	2015
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	168.9 KiB

Quantile statistics

Minimum	1900
5-th percentile	1915
Q1	1951
median	1975
Q3	1997
95-th percentile	2011
Maximum	2015
Range	115
Interquartile range (IQR)	46

Descriptive statistics

Standard deviation	29.375234
Coefficient of variation (CV)	0.014903723
Kurtosis	-0.65769443
Mean	1970.9997
Median Absolute Deviation (MAD)	23
Skewness	-0.46944998
Sum	42567680
Variance	862.90438
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2014	559	2.6%
2006	453	2.1%
2005	450	2.1%
2004	433	2.0%
2003	420	1.9%
2007	417	1.9%
1977	417	1.9%
1978	387	1.8%
1968	381	1.8%
2008	367	1.7%
Other values (106)	17313	80.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1900	87	0.4%
1901	29	0.1%
1902	27	0.1%
1903	46	0.2%
1904	45	0.2%
1905	74	0.3%
1906	92	0.4%
1907	65	0.3%
1908	86	0.4%
1909	94	0.4%

Value	Count	Frequency (%)
2015	38	0.2%
2014	559	2.6%
2013	201	0.9%
2012	170	0.8%
2011	130	0.6%
2010	143	0.7%
2009	230	1.1%
2008	367	1.7%
2007	417	1.9%
2006	453	2.1%

yr_renovated
Real number (ℝ)

MISSING ZEROS

Distinct	70
Distinct (%)	0.4%
Missing	3842
Missing (%)	17.8%
Infinite	0
Infinite (%)	0.0%
Mean	83.636778

Minimum	0
Maximum	2015
Zeros	17011
Zeros (%)	78.8%
Negative	0
Negative (%)	0.0%
Memory size	168.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	2015
Range	2015
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	399.94641
Coefficient of variation (CV)	4.7819443
Kurtosis	18.919543
Mean	83.636778
Median Absolute Deviation (MAD)	0
Skewness	4.5733852
Sum	1484971
Variance	159957.13
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	17011	78.8%
2014	73	0.3%
2013	31	0.1%
2003	31	0.1%
2007	30	0.1%
2000	29	0.1%
2005	29	0.1%
2004	22	0.1%
1990	22	0.1%
2009	21	0.1%
Other values (60)	456	2.1%
(Missing)	3842	17.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	17011	78.8%
1934	1	< 0.1%
1940	2	< 0.1%
1944	1	< 0.1%
1945	3	< 0.1%
1946	1	< 0.1%
1948	1	< 0.1%
1950	1	< 0.1%
1951	1	< 0.1%
1953	1	< 0.1%

Value	Count	Frequency (%)
2015	14	0.1%
2014	73	0.3%
2013	31	0.1%
2012	8	< 0.1%
2011	9	< 0.1%
2010	15	0.1%
2009	21	0.1%
2008	15	0.1%
2007	30	0.1%
2006	20	0.1%

zipcode
Real number (ℝ)

HIGH CORRELATION

Distinct	70
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	98077.952

Minimum	98001
Maximum	98199
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	168.9 KiB

Quantile statistics

Minimum	98001
5-th percentile	98004
Q1	98033
median	98065
Q3	98118
95-th percentile	98177
Maximum	98199
Range	198
Interquartile range (IQR)	85

Descriptive statistics

Standard deviation	53.513072
Coefficient of variation (CV)	0.00054561776
Kurtosis	-0.85400486
Mean	98077.952
Median Absolute Deviation (MAD)	42
Skewness	0.40532219
Sum	2.1181895 × 10⁹
Variance	2863.6489
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
98103	602	2.8%
98038	589	2.7%
98115	583	2.7%
98052	574	2.7%
98117	553	2.6%
98042	547	2.5%
98034	545	2.5%
98118	507	2.3%
98023	499	2.3%
98006	498	2.3%
Other values (60)	16100	74.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
98001	361	1.7%
98002	199	0.9%
98003	280	1.3%
98004	317	1.5%
98005	168	0.8%
98006	498	2.3%
98007	141	0.7%
98008	283	1.3%
98010	100	0.5%
98011	195	0.9%

Value	Count	Frequency (%)
98199	317	1.5%
98198	280	1.3%
98188	136	0.6%
98178	262	1.2%
98177	255	1.2%
98168	269	1.2%
98166	254	1.2%
98155	446	2.1%
98148	57	0.3%
98146	288	1.3%

lat
Real number (ℝ)

Distinct	5033
Distinct (%)	23.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	47.560093

Minimum	47.1559
Maximum	47.7776
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	168.9 KiB

Quantile statistics

Minimum	47.1559
5-th percentile	47.3103
Q1	47.4711
median	47.5718
Q3	47.678
95-th percentile	47.7497
Maximum	47.7776
Range	0.6217
Interquartile range (IQR)	0.2069

Descriptive statistics

Standard deviation	0.13855177
Coefficient of variation (CV)	0.0029131938
Kurtosis	-0.67579021
Mean	47.560093
Median Absolute Deviation (MAD)	0.1049
Skewness	-0.48552159
Sum	1027155.3
Variance	0.019196592
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
47.5491	17	0.1%
47.6846	17	0.1%
47.5322	17	0.1%
47.6624	17	0.1%
47.6711	16	0.1%
47.6955	16	0.1%
47.6886	16	0.1%
47.6647	15	0.1%
47.6904	15	0.1%
47.686	15	0.1%
Other values (5023)	21436	99.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
47.1559	1	< 0.1%
47.1593	1	< 0.1%
47.1622	1	< 0.1%
47.1647	1	< 0.1%
47.1764	1	< 0.1%
47.1775	1	< 0.1%
47.1776	2	< 0.1%
47.1795	1	< 0.1%
47.1803	1	< 0.1%
47.1808	1	< 0.1%

Value	Count	Frequency (%)
47.7776	3	< 0.1%
47.7775	3	< 0.1%
47.7774	1	< 0.1%
47.7772	3	< 0.1%
47.7771	2	< 0.1%
47.777	2	< 0.1%
47.7769	3	< 0.1%
47.7768	2	< 0.1%
47.7767	6	< 0.1%
47.7766	4	< 0.1%

long
Real number (ℝ)

HIGH CORRELATION

Distinct	751
Distinct (%)	3.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-122.21398

Minimum	-122.519
Maximum	-121.315
Zeros	0
Zeros (%)	0.0%
Negative	21597
Negative (%)	100.0%
Memory size	168.9 KiB

Quantile statistics

Minimum	-122.519
5-th percentile	-122.387
Q1	-122.328
median	-122.231
Q3	-122.125
95-th percentile	-121.9798
Maximum	-121.315
Range	1.204
Interquartile range (IQR)	0.203

Descriptive statistics

Standard deviation	0.14072353
Coefficient of variation (CV)	-0.001151452
Kurtosis	1.0521203
Mean	-122.21398
Median Absolute Deviation (MAD)	0.101
Skewness	0.88488834
Sum	-2639455.4
Variance	0.019803112
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-122.29	115	0.5%
-122.3	111	0.5%
-122.362	104	0.5%
-122.291	100	0.5%
-122.372	99	0.5%
-122.363	99	0.5%
-122.288	98	0.5%
-122.357	96	0.4%
-122.284	95	0.4%
-122.365	94	0.4%
Other values (741)	20586	95.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-122.519	1	< 0.1%
-122.515	1	< 0.1%
-122.514	1	< 0.1%
-122.512	1	< 0.1%
-122.511	2	< 0.1%
-122.509	2	< 0.1%
-122.507	1	< 0.1%
-122.506	1	< 0.1%
-122.505	3	< 0.1%
-122.504	2	< 0.1%

Value	Count	Frequency (%)
-121.315	2	< 0.1%
-121.316	1	< 0.1%
-121.319	1	< 0.1%
-121.321	1	< 0.1%
-121.325	1	< 0.1%
-121.352	2	< 0.1%
-121.359	1	< 0.1%
-121.364	2	< 0.1%
-121.402	1	< 0.1%
-121.403	1	< 0.1%

sqft_living15
Real number (ℝ)

HIGH CORRELATION

Distinct	777
Distinct (%)	3.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1986.6203

Minimum	399
Maximum	6210
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	168.9 KiB

Quantile statistics

Minimum	399
5-th percentile	1140
Q1	1490
median	1840
Q3	2360
95-th percentile	3300
Maximum	6210
Range	5811
Interquartile range (IQR)	870

Descriptive statistics

Standard deviation	685.23047
Coefficient of variation (CV)	0.34492271
Kurtosis	1.5917328
Mean	1986.6203
Median Absolute Deviation (MAD)	410
Skewness	1.1068754
Sum	42905039
Variance	469540.8
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1540	197	0.9%
1440	195	0.9%
1560	192	0.9%
1500	180	0.8%
1460	169	0.8%
1580	167	0.8%
1610	166	0.8%
1720	166	0.8%
1800	166	0.8%
1620	164	0.8%
Other values (767)	19835	91.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
399	1	< 0.1%
460	2	< 0.1%
620	2	< 0.1%
670	1	< 0.1%
690	2	< 0.1%
700	2	< 0.1%
710	2	< 0.1%
720	2	< 0.1%
740	8	< 0.1%
750	3	< 0.1%

Value	Count	Frequency (%)
6210	1	< 0.1%
6110	1	< 0.1%
5790	6	< 0.1%
5610	1	< 0.1%
5600	1	< 0.1%
5500	1	< 0.1%
5380	1	< 0.1%
5340	1	< 0.1%
5330	1	< 0.1%
5220	1	< 0.1%

sqft_lot15
Real number (ℝ)

HIGH CORRELATION

Distinct	8682
Distinct (%)	40.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	12758.284

Minimum	651
Maximum	871200
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	168.9 KiB

Quantile statistics

Minimum	651
5-th percentile	2002.4
Q1	5100
median	7620
Q3	10083
95-th percentile	37045.2
Maximum	871200
Range	870549
Interquartile range (IQR)	4983

Descriptive statistics

Standard deviation	27274.442
Coefficient of variation (CV)	2.137783
Kurtosis	151.39566
Mean	12758.284
Median Absolute Deviation (MAD)	2505
Skewness	9.524362
Sum	2.7554065 × 10⁸
Variance	7.4389518 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5000	427	2.0%
4000	356	1.6%
6000	288	1.3%
7200	210	1.0%
4800	145	0.7%
7500	142	0.7%
8400	116	0.5%
3600	111	0.5%
4500	111	0.5%
5100	109	0.5%
Other values (8672)	19582	90.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
651	1	< 0.1%
659	1	< 0.1%
660	1	< 0.1%
748	2	< 0.1%
750	4	< 0.1%
755	1	< 0.1%
757	1	< 0.1%
758	1	< 0.1%
788	1	< 0.1%
794	1	< 0.1%

Value	Count	Frequency (%)
871200	1	< 0.1%
858132	1	< 0.1%
560617	1	< 0.1%
438213	1	< 0.1%
434728	1	< 0.1%
425581	1	< 0.1%
422967	1	< 0.1%
411962	1	< 0.1%
392040	2	< 0.1%
386812	1	< 0.1%

Auto

Heatmap
Table

	id	price	bedrooms	bathrooms	sqft_living	sqft_lot	floors	sqft_above	yr_built	yr_renovated	zipcode	lat	long	sqft_living15	sqft_lot15	waterfront	view	condition	grade
id	1.000	0.004	0.006	0.015	0.002	-0.117	0.019	0.004	0.027	-0.013	-0.005	-0.004	0.007	0.000	-0.115	0.006	0.029	0.030	0.037
price	0.004	1.000	0.344	0.497	0.644	0.075	0.322	0.542	0.102	0.106	-0.009	0.456	0.064	0.572	0.063	0.333	0.207	0.023	0.295
bedrooms	0.006	0.344	1.000	0.521	0.648	0.217	0.228	0.540	0.181	0.014	-0.168	-0.022	0.193	0.444	0.202	0.016	0.038	0.012	0.081
bathrooms	0.015	0.497	0.521	1.000	0.746	0.069	0.548	0.691	0.568	0.042	-0.205	0.008	0.262	0.571	0.064	0.109	0.111	0.122	0.310
sqft_living	0.002	0.644	0.648	0.746	1.000	0.305	0.401	0.843	0.353	0.053	-0.207	0.031	0.285	0.747	0.285	0.151	0.147	0.056	0.369
sqft_lot	-0.117	0.075	0.217	0.069	0.305	1.000	-0.234	0.273	-0.037	0.005	-0.319	-0.122	0.371	0.360	0.922	0.022	0.041	0.040	0.042
floors	0.019	0.322	0.228	0.548	0.401	-0.234	1.000	0.599	0.551	0.010	-0.062	0.024	0.149	0.306	-0.231	0.017	0.022	0.178	0.245
sqft_above	0.004	0.542	0.540	0.691	0.843	0.273	0.599	1.000	0.472	0.029	-0.279	-0.026	0.386	0.697	0.255	0.084	0.089	0.106	0.359
yr_built	0.027	0.102	0.181	0.568	0.353	-0.037	0.551	0.472	1.000	-0.216	-0.317	-0.126	0.413	0.336	-0.016	0.035	0.042	0.248	0.195
yr_renovated	-0.013	0.106	0.014	0.042	0.053	0.005	0.010	0.029	-0.216	1.000	0.068	0.028	-0.080	-0.004	0.005	0.085	0.106	0.069	0.019
zipcode	-0.005	-0.009	-0.168	-0.205	-0.207	-0.319	-0.062	-0.279	-0.317	0.068	1.000	0.249	-0.577	-0.287	-0.326	0.078	0.074	0.074	0.110
lat	-0.004	0.456	-0.022	0.008	0.031	-0.122	0.024	-0.026	-0.126	0.028	0.249	1.000	-0.143	0.027	-0.116	0.033	0.068	0.057	0.116
long	0.007	0.064	0.193	0.262	0.285	0.371	0.149	0.386	0.413	-0.080	-0.577	-0.143	1.000	0.381	0.373	0.092	0.085	0.081	0.101
sqft_living15	0.000	0.572	0.444	0.571	0.747	0.360	0.306	0.697	0.336	-0.004	-0.287	0.027	0.381	1.000	0.366	0.092	0.147	0.062	0.326
sqft_lot15	-0.115	0.063	0.202	0.064	0.285	0.922	-0.231	0.255	-0.016	0.005	-0.326	-0.116	0.373	0.366	1.000	0.000	0.035	0.013	0.038
waterfront	0.006	0.333	0.016	0.109	0.151	0.022	0.017	0.084	0.035	0.085	0.078	0.033	0.092	0.092	0.000	1.000	0.599	0.019	0.129
view	0.029	0.207	0.038	0.111	0.147	0.041	0.022	0.089	0.042	0.106	0.074	0.068	0.085	0.147	0.035	0.599	1.000	0.025	0.142
condition	0.030	0.023	0.012	0.122	0.056	0.040	0.178	0.106	0.248	0.069	0.074	0.057	0.081	0.062	0.013	0.019	0.025	1.000	0.128
grade	0.037	0.295	0.081	0.310	0.369	0.042	0.245	0.359	0.195	0.019	0.110	0.116	0.101	0.326	0.038	0.129	0.142	0.128	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	id	date	price	bedrooms	bathrooms	sqft_living	sqft_lot	floors	waterfront	view	condition	grade	sqft_above	sqft_basement	yr_built	yr_renovated	zipcode	lat	long	sqft_living15	sqft_lot15
0	7129300520	10/13/2014	221900.0	3	1.00	1180	5650	1.0	NaN	NONE	Average	7 Average	1180	0.0	1955	0.0	98178	47.5112	-122.257	1340	5650
1	6414100192	12/9/2014	538000.0	3	2.25	2570	7242	2.0	NO	NONE	Average	7 Average	2170	400.0	1951	1991.0	98125	47.7210	-122.319	1690	7639
2	5631500400	2/25/2015	180000.0	2	1.00	770	10000	1.0	NO	NONE	Average	6 Low Average	770	0.0	1933	NaN	98028	47.7379	-122.233	2720	8062
3	2487200875	12/9/2014	604000.0	4	3.00	1960	5000	1.0	NO	NONE	Very Good	7 Average	1050	910.0	1965	0.0	98136	47.5208	-122.393	1360	5000
4	1954400510	2/18/2015	510000.0	3	2.00	1680	8080	1.0	NO	NONE	Average	8 Good	1680	0.0	1987	0.0	98074	47.6168	-122.045	1800	7503
5	7237550310	5/12/2014	1230000.0	4	4.50	5420	101930	1.0	NO	NONE	Average	11 Excellent	3890	1530.0	2001	0.0	98053	47.6561	-122.005	4760	101930
6	1321400060	6/27/2014	257500.0	3	2.25	1715	6819	2.0	NO	NONE	Average	7 Average	1715	?	1995	0.0	98003	47.3097	-122.327	2238	6819
7	2008000270	1/15/2015	291850.0	3	1.50	1060	9711	1.0	NO	NaN	Average	7 Average	1060	0.0	1963	0.0	98198	47.4095	-122.315	1650	9711
8	2414600126	4/15/2015	229500.0	3	1.00	1780	7470	1.0	NO	NONE	Average	7 Average	1050	730.0	1960	0.0	98146	47.5123	-122.337	1780	8113
9	3793500160	3/12/2015	323000.0	3	2.50	1890	6560	2.0	NO	NONE	Average	7 Average	1890	0.0	2003	0.0	98038	47.3684	-122.031	2390	7570

	id	date	price	bedrooms	bathrooms	sqft_living	sqft_lot	floors	waterfront	view	condition	grade	sqft_above	sqft_basement	yr_built	zipcode	lat	long	sqft_living15	sqft_lot15
21587	7852140040	8/25/2014	507250.0	3	2.50	2270	5536	2.0	NaN	NONE	Average	8 Good	2270	0.0	2003	98065	47.5389	-121.881	2270	5731
21588	9834201367	1/26/2015	429000.0	3	2.00	1490	1126	3.0	NO	NONE	Average	8 Good	1490	0.0	2014	98144	47.5699	-122.288	1400	1230
21589	3448900210	10/14/2014	610685.0	4	2.50	2520	6023	2.0	NO	NaN	Average	9 Better	2520	0.0	2014	98056	47.5137	-122.167	2520	6023
21590	7936000429	3/26/2015	1010000.0	4	3.50	3510	7200	2.0	NO	NONE	Average	9 Better	2600	910.0	2009	98136	47.5537	-122.398	2050	6200
21591	2997800021	2/19/2015	475000.0	3	2.50	1310	1294	2.0	NO	NONE	Average	8 Good	1180	130.0	2008	98116	47.5773	-122.409	1330	1265
21592	263000018	5/21/2014	360000.0	3	2.50	1530	1131	3.0	NO	NONE	Average	8 Good	1530	0.0	2009	98103	47.6993	-122.346	1530	1509
21593	6600060120	2/23/2015	400000.0	4	2.50	2310	5813	2.0	NO	NONE	Average	8 Good	2310	0.0	2014	98146	47.5107	-122.362	1830	7200
21594	1523300141	6/23/2014	402101.0	2	0.75	1020	1350	2.0	NO	NONE	Average	7 Average	1020	0.0	2009	98144	47.5944	-122.299	1020	2007
21595	291310100	1/16/2015	400000.0	3	2.50	1600	2388	2.0	NaN	NONE	Average	8 Good	1600	0.0	2004	98027	47.5345	-122.069	1410	1287
21596	1523300157	10/15/2014	325000.0	2	0.75	1020	1076	2.0	NO	NONE	Average	7 Average	1020	0.0	2008	98144	47.5941	-122.299	1020	1357

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Decimal Number

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Missing values

Sample